﻿CREATE PROCEDURE [dbo].[proc_RoleGroupAppList_GetList]
	/*
	(
	@parameter1 int = 5,
	@parameter2 datatype OUTPUT
	)
	*/
AS
Select
L.Id,
L.RoleId,
L.SysAppId,
L.CreateTime,
/*A.CName,*/
(Select CName From AppController Where Id=A.CId) As CName,
A.AName
From RoleGroupAppList L inner join AppAction As A On L.SysAppId=A.Id
RETURN
